<Page id="1" templateExtension="html" relativePath="." fullRelativePath="." secured="False" urlType="Relative" isIncluded="False" SSLAccess="False" wizardTheme="Aqua" wizardThemeType="File" needGeneration="0">
	<Components>
		<Grid id="2" secured="False" sourceType="SQL" returnValueType="Number" defaultPageSize="10" connection="projectkar" dataSource="SELECT ALL ITEM.NAME item_name, &quot;USER&quot;.NAME owner, ITEM.CRT_DATE, ITEM.MONEY, ITEM.ID,NVL(max_sug.num,0) NUM 
 FROM ITEM, &quot;USER&quot;,
       (select ite_id,count(suggest.id) num 
         from suggest
         group by ite_id
         order by num) max_sug
 WHERE 
           (ITEM.USE_ID = &quot;USER&quot;.ID) and
           (max_sug.ite_id(+)=item.id)
 ORDER BY NUM" name="ITEM_USER" pageSizeLimit="100" wizardCaption="List of ITEM, &quot; USER&quot; " wizardTheme="Aqua" wizardThemeType="File" wizardGridType="Tabular" wizardAllowInsert="False" wizardAltRecord="False" wizardRecordSeparator="False">
			<Components>
				<Label id="11" fieldSourceType="DBColumn" dataType="Text" html="False" editable="False" name="ITEM_NAME" fieldSource="ITEM_NAME" wizardCaption="ITEM NAME" wizardTheme="Aqua" wizardThemeType="File" wizardSize="20" wizardMaxLength="20" wizardIsPassword="False" wizardUseTemplateBlock="False">
					<Components/>
					<Events/>
				</Label>
				<Label id="12" fieldSourceType="DBColumn" dataType="Text" html="False" editable="False" name="USER_NAME" fieldSource="OWNER" wizardCaption="USER NAME" wizardTheme="Aqua" wizardThemeType="File" wizardSize="20" wizardMaxLength="20" wizardIsPassword="False" wizardUseTemplateBlock="False">
					<Components/>
					<Events/>
				</Label>
				<Label id="13" fieldSourceType="DBColumn" dataType="Date" html="False" editable="False" name="CRT_DATE" fieldSource="CRT_DATE" wizardCaption="CRT DATE" wizardTheme="Aqua" wizardThemeType="File" wizardSize="10" wizardMaxLength="26" wizardIsPassword="False" wizardUseTemplateBlock="False">
					<Components/>
					<Events/>
				</Label>
				<Label id="14" fieldSourceType="DBColumn" dataType="Float" html="False" editable="False" name="MONEY" fieldSource="MONEY" wizardCaption="MONEY" wizardTheme="Aqua" wizardThemeType="File" wizardSize="12" wizardMaxLength="12" wizardIsPassword="False" wizardUseTemplateBlock="False">
					<Components/>
					<Events/>
				</Label>
				<Label id="15" fieldSourceType="DBColumn" dataType="Float" html="False" editable="False" name="sugg_num" fieldSource="NUM" wizardCaption="USER ID" wizardTheme="Aqua" wizardThemeType="File" wizardSize="12" wizardMaxLength="12" wizardIsPassword="False" wizardUseTemplateBlock="False">
					<Components/>
					<Events/>
				</Label>
				<Navigator id="16" name="Navigator" wizardPagingType="ImageButtons" wizardFirst="False" wizardFirstText="First" wizardPrev="True" wizardPrevText="Prev" wizardNext="True" wizardNextText="Next" wizardLast="False" wizardLastText="Last" wizardImages="True" wizardSize="10" wizardTotalPages="False" wizardHideDisabled="False" wizardOfText="of" wizardTheme="Aqua" wizardThemeType="File" wizardImagesScheme="Aqua" type="Simple">
					<Components/>
					<Events/>
				</Navigator>
			</Components>
			<Events/>
			<TableParameters/>
			<JoinTables>
				<JoinTable id="3" tableName="ITEM" posWidth="100" posHeight="308" posLeft="10" posTop="10"/>
				<JoinTable id="7" tableName="&quot;USER&quot;" posWidth="100" posHeight="219" posLeft="246" posTop="20"/>
			</JoinTables>
			<JoinLinks>
				<JoinTable2 id="10" fieldLeft="ITEM.USE_ID" fieldRight="&quot;USER&quot;.ID" tableLeft="ITEM" tableRight="&quot;USER&quot;" conditionType="Equal" joinType="inner"/>
			</JoinLinks>
			<Fields>
				<Field id="4" tableName="ITEM" alias="ITEM_NAME" fieldName="ITEM.NAME"/>
				<Field id="5" tableName="ITEM" fieldName="MONEY"/>
				<Field id="6" tableName="ITEM" fieldName="CRT_DATE"/>
				<Field id="8" tableName="&quot;USER&quot;" alias="USER_NAME" fieldName="&quot;USER&quot;.NAME"/>
				<Field id="9" tableName="&quot;USER&quot;" alias="USER_ID" fieldName="&quot;USER&quot;.ID"/>
			</Fields>
			<SPParameters/>
			<SQLParameters/>
			<SecurityGroups/>
		</Grid>
	</Components>
	<CodeFiles>
		<CodeFile id="Model" language="JSP" name="see_popular_softwares.xml" path="." comment="&lt;!--" commentEnd="--&gt;" codePage="iso-8859-1" forShow="False"/>
		<CodeFile id="JSP" language="JSP" name="see_popular_softwares.jsp" path="." comment="&lt;%--" commentEnd="--%&gt;" codePage="iso-8859-1" forShow="True" url="see_popular_softwares.jsp"/>
		<CodeFile id="Handlers" language="JSP" name="see_popular_softwaresHandlers.jsp" path="." comment="//" codePage="iso-8859-1" forShow="False"/>
	</CodeFiles>
	<SecurityGroups/>
	<Events/>
</Page>
